package tablesqls

func CreateCategoryTableSql() (sql string) {
	sql = "CREATE TABLE `category` ("
	sql += "`id` int(10) unsigned NOT NULL AUTO_INCREMENT,"
	sql += "`parent_id` int(11) NOT NULL DEFAULT '0',"
	sql += "`sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',"
	sql += "`title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',"
	sql += "`icon` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图标',"
	sql += "`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',"
	sql += "`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',"
	sql += "`is_used` tinyint(4) DEFAULT '-1' COMMENT '是否启用 1:是 -1:否',"
	sql += "`level` tinyint(1) DEFAULT NULL COMMENT '分类等级',"
	sql += "PRIMARY KEY (`id`) USING BTREE"
	sql += ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='站分类';"
	return
}

func CreateCategoryTableDataSql() (sql string) {
	sql = "INSERT INTO category (parent_id,sort,title,icon,created_at,updated_at,is_used,`level`) VALUES"
	sql += "(0,1,'常用推荐','briefcase-alt','2019-01-21 12:48:58','2023-03-10 17:46:19',1,1),"
	sql += "(0,2,'社区资讯','envelope','2019-01-21 12:50:17','2023-03-10 17:46:31',1,1),"
	sql += "(0,5,'灵感采集','radio-button','2019-01-21 13:53:10','2023-03-10 17:47:37',1,1),"
	sql += "(3,4,'发现产品','fa-star-o','2019-01-21 13:53:31','2019-01-21 13:53:34',1,2),"
	sql += "(3,5,'界面灵感','fa-star-o','2019-01-21 13:53:49','2019-01-21 13:55:42',1,2),"
	sql += "(3,6,'网页灵感','fa-star-o','2019-01-21 13:54:00','2019-01-21 13:55:42',1,2),"
	sql += "(0,7,'素材资源','radio-button','2019-01-21 13:54:42','2023-03-10 17:47:47',1,1),"
	sql += "(7,8,'图标素材','fa-star-o','2019-01-21 13:54:59','2019-01-21 14:12:01',1,2),"
	sql += "(7,9,'LOGO设计','fa-star-o','2019-01-21 13:55:11','2019-01-21 13:55:42',1,2),"
	sql += "(7,10,'平面素材','fa-star-o','2019-01-21 13:55:25','2019-01-21 13:55:42',1,2),"
	sql += "(7,11,'UI资源','fa-star-o','2019-01-21 13:55:31','2019-01-21 13:55:42',1,2),"
	sql += "(7,12,'Sketch资源','fa-star-o','2019-01-22 01:00:51','2019-01-22 01:07:04',1,2),"
	sql += "(7,13,'字体资源','fa-star-o','2019-01-22 01:01:02','2019-01-22 01:07:04',1,2),"
	sql += "(7,14,'Mockup','fa-star-o','2019-01-22 01:01:12','2019-01-22 01:07:04',1,2),"
	sql += "(7,15,'摄影图库','fa-star-o','2019-01-22 01:01:23','2019-01-22 01:07:04',1,2),"
	sql += "(7,16,'PPT资源','fa-star-o','2019-01-22 01:01:33','2019-01-22 01:07:04',1,2),"
	sql += "(0,17,'常用工具','radio-button','2019-01-22 01:02:04','2023-03-10 17:48:01',1,1),"
	sql += "(17,18,'图形创意','fa-star-o','2019-01-22 01:02:14','2019-01-22 01:07:04',1,2),"
	sql += "(17,19,'界面设计','fa-star-o','2019-01-22 01:02:24','2019-01-22 01:07:04',1,2),"
	sql += "(17,20,'交互动效','fa-star-o','2019-01-22 01:02:32','2019-01-22 01:07:04',1,2),"
	sql += "(17,21,'在线配色','fa-star-o','2019-01-22 01:02:40','2019-01-22 01:07:04',1,2),"
	sql += "(17,22,'在线工具','fa-star-o','2019-01-22 01:02:49','2019-01-22 01:07:04',1,2),"
	sql += "(17,23,'Chrome插件','fa-star-o','2019-01-22 01:02:58','2019-01-22 01:07:04',1,2),"
	sql += "(0,24,'学习教程','radio-button','2019-01-22 01:03:17','2023-03-10 17:48:09',1,1),"
	sql += "(24,25,'设计规范','fa-star-o','2019-01-22 01:03:29','2019-01-22 01:07:04',1,2),"
	sql += "(24,26,'视频教程','fa-star-o','2019-01-22 01:03:36','2019-01-22 01:07:04',1,2),"
	sql += "(24,27,'设计文章','fa-star-o','2019-01-22 01:03:44','2019-01-22 01:07:04',1,2),"
	sql += "(24,28,'设计电台','fa-star-o','2019-01-22 01:03:52','2019-01-22 01:07:04',1,2),"
	sql += "(0,0,'小玩意儿','bulb','2019-07-26 16:08:10','2023-03-10 17:50:15',1,1),"
	sql += "(0,1,'常用搜索','sketch','2019-12-19 10:14:01','2023-03-10 17:45:59',1,1),"
	sql += "(0,3,'休闲娱乐','star-half','2019-12-19 10:45:08','2023-03-10 17:46:54',1,1),"
	sql += "(0,4,'IT技术','pointer-left','2019-12-19 11:14:21','2023-03-10 17:47:10',1,1),"
	sql += "(17,2,'网站管理','fa-align-justify','2019-12-19 21:53:17','2019-12-19 21:53:17',1,2),"
	sql += "(17,39,'常用邮箱登录入口','fa-angellist','2019-12-20 19:36:52','2019-12-20 19:36:52',1,2);"
	return
}
